* append_labor_force.do
* This file appends the ocupados, desocupados and inactivos datasets, in order to build a dataset to calculate employment rates.



*************************** Change log ********************************** 

/*
	
*/


clear all
version 13.1

* Project info
cap project, doinfo
if _rc==198 {
	if c(os)=="Unix" loc master "/home/jperez/AA_Minimum_Wage" 
 else if c(username)=="J16339" loc master "B:\Col_Minimum_Wage"
	else loc master "C:/Users/jorpp/Dropbox (Brown)/Col_Minimum_Wage"
 loc pr = 0
}
else {
	local master "`r(pdir)'"
	local doname "`r(dofile)'"  
 loc pr = 1
	* Project calls
project, uses("`master'/Data/Source/ocupados.dta")
project, uses("`master'/Data/Source/desocupados.dta")
project, uses("`master'/Data/Source/inactivos.dta")

}



use "`master'/Data/Source/ocupados.dta"
append using "`master'/Data/Source/desocupados.dta"
append using "`master'/Data/Source/inactivos.dta"

* Each dataset has laborforce, so drop repeated obs
keep if ocupado==3 | desocupado==3 | inactivo == 3

save "`master'/Data/Source/fuerza_trabajo.dta", replace

* Project calls
project, creates("`master'/Data/Source/fuerza_trabajo.dta")
